package com.zhuiyun.educations.api.memberVo.mapper;

import com.zhuiyun.educations.api.memberVo.entity.MemberVo;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface MemberVoMapper {
    /**
    * @Author MJL
    * @Description todo pc端会员卡页面信息
    * @Date 2023/7/12 19:28
    * @Return  * @param null
    */
    @Select("SELECT b.id,b.user_id,b.member_id,b.close_time\n" +
            ",b.create_time,b.update_time,\n" +
            "b.del_flag,m.id,m.member_type,m.member_price,\n" +
            "m.member_time,m.member_notes,m.member_state,\n" +
            "u.id,u.login_name,u.avatar_url FROM become b \n" +
            "LEFT JOIN `user` u \n" +
            "ON b.user_id = u.id \n" +
            "LEFT JOIN member m \n" +
            "ON b.member_id = m.id \n" +
            "WHERE b.del_flag = 0 and b.id = #{id}")
    List<MemberVo> MemberVoList();
}
